Telegram Group & Telegram Channel
This media is not supported in your browser
VIEW IN TELEGRAM
Excel да массивлардан фойдаланиш.

Формулалар тузганда ячейкадан ташқари диапазонлар билан ишлаш мумкин.
Мисол: устунни каторга кўпайтириш орқали, қатор ва устундаги хар битта ячейкани бир бирига кўпайтириш мумкин.

Буни амалга ошириш учун куйидаги кетма кетликни бажаринг:

1️⃣ Бўлажак натижалар диапазонини танлаб баробар белгисини куйинг,
2️⃣ "=" белгидан сўнг устун диапазонини қатор диапазонига кўпайтиринг.
3️⃣ Ва охирида Ctrl + Shift + Enter бирикмасини босинг. Карра жадвали тайёр. 😉

P.S. Эслатиб ўтаман, Excel Hacks видеокурсимизга ҳозирги кунда 20 фоизли акция кетмоқда.
1С видеокурсини сотиб олганлар учун эса Excel видеокурси бепул берилади. 👉🏻 🛒


Excel Hacks видеокурси | 1C видеокурси



tg-me.com/excel_hacks/572
Create:
Last Update:

Excel да массивлардан фойдаланиш.

Формулалар тузганда ячейкадан ташқари диапазонлар билан ишлаш мумкин.
Мисол: устунни каторга кўпайтириш орқали, қатор ва устундаги хар битта ячейкани бир бирига кўпайтириш мумкин.

Буни амалга ошириш учун куйидаги кетма кетликни бажаринг:

1️⃣ Бўлажак натижалар диапазонини танлаб баробар белгисини куйинг,
2️⃣ "=" белгидан сўнг устун диапазонини қатор диапазонига кўпайтиринг.
3️⃣ Ва охирида Ctrl + Shift + Enter бирикмасини босинг. Карра жадвали тайёр. 😉

P.S. Эслатиб ўтаман, Excel Hacks видеокурсимизга ҳозирги кунда 20 фоизли акция кетмоқда.
1С видеокурсини сотиб олганлар учун эса Excel видеокурси бепул берилади. 👉🏻 🛒


Excel Hacks видеокурси | 1C видеокурси

BY Excel Hacks


Share with your friend now:
tg-me.com/excel_hacks/572

View MORE
Open in Telegram


Excel Hacks Telegram | DID YOU KNOW?

Date: |

Should You Buy Bitcoin?

In general, many financial experts support their clients’ desire to buy cryptocurrency, but they don’t recommend it unless clients express interest. “The biggest concern for us is if someone wants to invest in crypto and the investment they choose doesn’t do well, and then all of a sudden they can’t send their kids to college,” says Ian Harvey, a certified financial planner (CFP) in New York City. “Then it wasn’t worth the risk.” The speculative nature of cryptocurrency leads some planners to recommend it for clients’ “side” investments. “Some call it a Vegas account,” says Scott Hammel, a CFP in Dallas. “Let’s keep this away from our real long-term perspective, make sure it doesn’t become too large a portion of your portfolio.” In a very real sense, Bitcoin is like a single stock, and advisors wouldn’t recommend putting a sizable part of your portfolio into any one company. At most, planners suggest putting no more than 1% to 10% into Bitcoin if you’re passionate about it. “If it was one stock, you would never allocate any significant portion of your portfolio to it,” Hammel says.

Among the actives, Ascendas REIT sank 0.64 percent, while CapitaLand Integrated Commercial Trust plummeted 1.42 percent, City Developments plunged 1.12 percent, Dairy Farm International tumbled 0.86 percent, DBS Group skidded 0.68 percent, Genting Singapore retreated 0.67 percent, Hongkong Land climbed 1.30 percent, Mapletree Commercial Trust lost 0.47 percent, Mapletree Logistics Trust tanked 0.95 percent, Oversea-Chinese Banking Corporation dropped 0.61 percent, SATS rose 0.24 percent, SembCorp Industries shed 0.54 percent, Singapore Airlines surrendered 0.79 percent, Singapore Exchange slid 0.30 percent, Singapore Press Holdings declined 1.03 percent, Singapore Technologies Engineering dipped 0.26 percent, SingTel advanced 0.81 percent, United Overseas Bank fell 0.39 percent, Wilmar International eased 0.24 percent, Yangzijiang Shipbuilding jumped 1.42 percent and Keppel Corp, Thai Beverage, CapitaLand and Comfort DelGro were unchanged.

Excel Hacks from ar


Telegram Excel Hacks
FROM USA